|
QAL is an open source development project that aims to create a collection of libraries for mixing, moving, merging, substituting and transforming data.〔(Sourceforge project page )〕 And in some cases, like for MongoDB, schemas. Sources and destinations include different database backends, file formats like .csv, XML and spreadsheets. Even untidy HTML web pages can be used as both a source and destination. For , it has a database abstraction layer that supports basic connectivity to Postgres, MySQL, DB2, Oracle and MS SQL server.〔(Database backends )〕 It uses XML formats(the SQL schema is self-generated) for representation of queries, transformation and merging, making it all scriptable. With regards to SQL, QAL uses a subset of SQL features〔(SQL features supported )〕 and data types,〔(SQL data types )〕 which while obviously not complete however is sufficient for most usages. It is however easy to instead use backend specific SQL when the queries do not have to be backend-agnostic. It is currently distributed as a Python Library (.egg)〔(PyPi repository page )〕 and a Debian package file(.deb).〔(Downloadable files )〕 It is related to the Optimal BPM(Business Process Management) project.〔(Optimal BPM site )〕 In fact, the Optimal BPM sourceforge project used to be DAL/QAL.〔 ==References== 抄文引用元・出典: フリー百科事典『 ウィキペディア（Wikipedia）』 ■ウィキペディアで「Query Abstraction Layer」の詳細全文を読む スポンサード リンク
|